Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_USTATS

`ALL_USTATS` describes all user-defined statistics accessible to the current user.

Related Views

- `DBA_USTATS` describes all user-defined statistics in the database.

- `USER_USTATS` describes all user-defined statistics owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OBJECT_OWNER` | `VARCHAR2(30)` |  | Owner of the table or index for which the statistics have been collected
`OBJECT_NAME` | `VARCHAR2(30)` |  | Name of the table or index for which the statistics have been collected
`OBJECT_TYPE` | `VARCHAR2(6)` |  | Indicates the type of object for which statistics have been collected: `COLUMN` or `INDEX`
`ASSOCIATION` | `VARCHAR2(8)` |  | `DIRECT` Indicates a direct association with the object for which the statistics have been collected. `IMPLICIT` indicates the association for which the statistics have been collected is with the column type or index type, and the object is an instance of that column type or index type.
`COLUMN_NAME` | `VARCHAR2(30)` |  | Column name, if property is column for which statistics have been collected
`STATSTYPE_SCHEMA` | `VARCHAR2(30)` |  | Schema of statistics type which was used to collect the statistics
`STATSTYPE_NAME` | `VARCHAR2(30)` |  | Name of statistics type which was used to collect statistics
`STATISTICS` | `RAW(2000)` |  | User collected statistics for the object
`PARTITION_NAME` | `VARCHAR2(30)` |  | Partition name of a table. If null, the table is either non-partitioned or the entry corresponds to the aggregate statistics for the table.